<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_supplier_rebate`;");
E_C("CREATE TABLE `ecs_supplier_rebate` (
  `rebate_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rebate_paytime_start` int(10) unsigned NOT NULL,
  `rebate_paytime_end` int(10) unsigned NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL,
  `is_pay_ok` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `pay_type` varchar(100) NOT NULL DEFAULT '',
  `pay_time` int(10) unsigned NOT NULL,
  `remark` varchar(255) NOT NULL DEFAULT '',
  `admin_user` varchar(100) NOT NULL,
  PRIMARY KEY (`rebate_id`),
  KEY `cat_type` (`rebate_paytime_end`),
  KEY `supplier_id` (`supplier_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_supplier_rebate` values('1','1410969600','1412092799','2','0','','0','','');");
E_D("replace into `ecs_supplier_rebate` values('2','1410969600','1412092799','3','0','','0','','');");
E_D("replace into `ecs_supplier_rebate` values('3','1410969600','1412092799','1','0','','0','','');");
E_D("replace into `ecs_supplier_rebate` values('4','1412092800','1420041599','1','0','','0','','');");
E_D("replace into `ecs_supplier_rebate` values('5','1412092800','1420041599','2','0','','0','','');");
E_D("replace into `ecs_supplier_rebate` values('6','1413907200','1414771199','9','0','','0','','');");
E_D("replace into `ecs_supplier_rebate` values('7','1412092800','1420041599','3','0','','0','','');");
E_D("replace into `ecs_supplier_rebate` values('8','1417708800','1420041599','19','0','','0','','');");
E_D("replace into `ecs_supplier_rebate` values('9','1417708800','1420041599','21','0','','0','','');");
E_D("replace into `ecs_supplier_rebate` values('10','1418140800','1420041599','18','0','','0','','');");
E_D("replace into `ecs_supplier_rebate` values('11','1418313600','1420041599','22','0','','0','','');");

require("../../inc/footer.php");
?>